# -*- coding: utf-8 -*-
"""
创建NBA球队数据表的SQL语句，共有58个表，DBMS为MySQL。
"""

# 1 nab现役球队表
nba_active_team = """CREATE TABLE IF NOT EXISTS nba_active_team(
at_id  int  NOT NULL  AUTO_INCREMENT,
at_name  varchar(100)  NOT NULL  COMMENT '队名',
at_area  varchar(100)  NOT NULL  COMMENT '地区',
at_detailed_area  varchar(100)  NOT NULL  COMMENT '详细地区',
PRIMARY KEY(at_id)
)ENGINE=InnoDB;
"""

# 2 nba/aba历史球队表
nba_history_team = """CREATE TABLE IF NOT EXISTS nba_history_team(
ht_id  int  NOT NULL  AUTO_INCREMENT,
ht_name  varchar(100)  NOT NULL  COMMENT '队名',
PRIMARY KEY(ht_id)
)ENGINE=InnoDB;
"""

# 3 球队简介数据表
team_brief_introduction = """CREATE TABLE IF NOT EXISTS team_brief_introduction(
bi_id  int  NOT NULL  AUTO_INCREMENT,
bi_name  varchar(100)  NOT NULL  COMMENT '中文名',
bi_English_name  varchar(255)  COMMENT '英文名',
bi_champion_season  varchar(255)  COMMENT '夺冠赛季',
bi_retired_number  varchar(255)  COMMENT '退役球衣',
PRIMARY KEY(bi_id)
)ENGINE=InnoDB;
"""

# 4 球队历年效力球员常规赛数据表
team_player_date_regular = """CREATE TABLE IF NOT EXISTS team_player_date_regular(
pdr_id  int  NOT NULL  AUTO_INCREMENT,
pdr_name  varchar(100)  NOT NULL  COMMENT '球队名',
pdr_season  varchar(100)  NOT NULL  COMMENT '赛季',
pdr_player  varchar(100)  NOT NULL  COMMENT '球员',
pdr_appearance  varchar(100)  COMMENT '出场',
pdr_starting  varchar(100)  COMMENT '首发',
pdr_time  varchar(100)  COMMENT '时间',
pdr_shot  varchar(100)  COMMENT '投篮',
pdr_shot_hit  varchar(100)  COMMENT '投篮命中',
pdr_shot_shot  varchar(100)  COMMENT '投篮出手',
pdr_three_points  varchar(100)  COMMENT '三分球',
pdr_three_points_hit  varchar(100)  COMMENT '三分命中',
pdr_three_points_shot  varchar(100)  COMMENT '三分出手',
pdr_penalty  varchar(100)  COMMENT '罚球',
pdr_penalty_hit  varchar(100)  COMMENT '罚球命中',
pdr_penalty_shot  varchar(100)  COMMENT '罚球出手',
pdr_backboard  varchar(100)  COMMENT '篮板',
pdr_backboard_front  varchar(100)  COMMENT '前场篮板',
pdr_backboard_back  varchar(100)  COMMENT '后场篮板',
pdr_assist  varchar(100)  COMMENT '助攻',
pdr_steal  varchar(100)  COMMENT '抢断',
pdr_cap  varchar(100)  COMMENT '盖帽',
pdr_mistake  varchar(100)  COMMENT '失误',
pdr_foul  varchar(100)  COMMENT '犯规',
pdr_score  varchar(100)  COMMENT '得分',
PRIMARY KEY(pdr_id)
)ENGINE=InnoDB;
"""

# 5 球队历年效力球员常规赛全队数据表
team_player_count_data_regular = """CREATE TABLE IF NOT EXISTS team_player_count_data_regular(
pcdr_id  int  NOT NULL  AUTO_INCREMENT,
pcdr_name  varchar(100)  NOT NULL  COMMENT '球队名',
pcdr_season  varchar(100)  NOT NULL  COMMENT '赛季',
pcdr_total  varchar(100)  NOT NULL  COMMENT '总计',
pcdr_session  varchar(100)  COMMENT '场次',
pcdr_win  varchar(100)  COMMENT '胜',
pcdr_negative  varchar(100)  COMMENT '负',
pcdr_shot  varchar(100)  COMMENT '投篮',
pcdr_shot_hit  varchar(100)  COMMENT '投篮命中',
pcdr_shot_shot  varchar(100)  COMMENT '投篮出手',
pcdr_three_points  varchar(100)  COMMENT '三分球',
pcdr_three_points_hit  varchar(100)  COMMENT '三分命中',
pcdr_three_points_shot  varchar(100)  COMMENT '三分出手',
pcdr_penalty  varchar(100)  COMMENT '罚球',
pcdr_penalty_hit  varchar(100)  COMMENT '罚球命中',
pcdr_penalty_shot  varchar(100)  COMMENT '罚球出手',
pcdr_backboard  varchar(100)  COMMENT '篮板',
pcdr_backboard_front  varchar(100)  COMMENT '前场篮板',
pcdr_backboard_back  varchar(100)  COMMENT '后场篮板',
pcdr_assist  varchar(100)  COMMENT '助攻',
pcdr_steal  varchar(100)  COMMENT '抢断',
pcdr_cap  varchar(100)  COMMENT '盖帽',
pcdr_mistake  varchar(100)  COMMENT '失误',
pcdr_foul  varchar(100)  COMMENT '犯规',
pcdr_score  varchar(100)  COMMENT '得分',
PRIMARY KEY(pcdr_id)
)ENGINE=InnoDB;
"""

# 6 球队历年效力球员季后赛数据表
team_player_date_playoff = """CREATE TABLE IF NOT EXISTS team_player_date_playoff(
pdp_id  int  NOT NULL  AUTO_INCREMENT,
pdp_name  varchar(100)  NOT NULL  COMMENT '球队名',
pdp_season  varchar(100)  NOT NULL  COMMENT '赛季',
pdp_player  varchar(100)  NOT NULL  COMMENT '球员',
pdp_appearance  varchar(100)  COMMENT '出场',
pdp_time  varchar(100)  COMMENT '时间',
pdp_shot  varchar(100)  COMMENT '投篮',
pdp_shot_hit  varchar(100)  COMMENT '投篮命中',
pdp_shot_shot  varchar(100)  COMMENT '投篮出手',
pdp_three_points  varchar(100)  COMMENT '三分球',
pdp_three_points_hit  varchar(100)  COMMENT '三分命中',
pdp_three_points_shot  varchar(100)  COMMENT '三分出手',
pdp_penalty  varchar(100)  COMMENT '罚球',
pdp_penalty_hit  varchar(100)  COMMENT '罚球命中',
pdp_penalty_shot  varchar(100)  COMMENT '罚球出手',
pdp_backboard  varchar(100)  COMMENT '篮板',
pdp_backboard_front  varchar(100)  COMMENT '前场篮板',
pdp_backboard_back  varchar(100)  COMMENT '后场篮板',
pdp_assist  varchar(100)  COMMENT '助攻',
pdp_steal  varchar(100)  COMMENT '抢断',
pdp_cap  varchar(100)  COMMENT '盖帽',
pdp_mistake  varchar(100)  COMMENT '失误',
pdp_foul  varchar(100)  COMMENT '犯规',
pdp_score  varchar(100)  COMMENT '得分',
PRIMARY KEY(pdp_id)
)ENGINE=InnoDB;
"""

# 7 球队历年效力球员季后赛全队数据表
team_player_count_data_playoff = """CREATE TABLE IF NOT EXISTS team_player_count_data_playoff(
pcdp_id  int  NOT NULL  AUTO_INCREMENT,
pcdp_name  varchar(100)  NOT NULL  COMMENT '球队名',
pcdp_season  varchar(100)  NOT NULL  COMMENT '赛季',
pcdp_total  varchar(100)  NOT NULL  COMMENT '总计',
pcdp_session  varchar(100)  COMMENT '场次',
pcdp_win  varchar(100)  COMMENT '胜',
pcdp_negative  varchar(100)  COMMENT '负',
pcdp_shot  varchar(100)  COMMENT '投篮',
pcdp_shot_hit  varchar(100)  COMMENT '投篮命中',
pcdp_shot_shot  varchar(100)  COMMENT '投篮出手',
pcdp_three_points  varchar(100)  COMMENT '三分球',
pcdp_three_points_hit  varchar(100)  COMMENT '三分命中',
pcdp_three_points_shot  varchar(100)  COMMENT '三分出手',
pcdp_penalty  varchar(100)  COMMENT '罚球',
pcdp_penalty_hit  varchar(100)  COMMENT '罚球命中',
pcdp_penalty_shot  varchar(100)  COMMENT '罚球出手',
pcdp_backboard  varchar(100)  COMMENT '篮板',
pcdp_backboard_front  varchar(100)  COMMENT '前场篮板',
pcdp_backboard_back  varchar(100)  COMMENT '后场篮板',
pcdp_assist  varchar(100)  COMMENT '助攻',
pcdp_steal  varchar(100)  COMMENT '抢断',
pcdp_cap  varchar(100)  COMMENT '盖帽',
pcdp_mistake  varchar(100)  COMMENT '失误',
pcdp_foul  varchar(100)  COMMENT '犯规',
pcdp_score  varchar(100)  COMMENT '得分',
PRIMARY KEY(pcdp_id)
)ENGINE=InnoDB;
"""

# 8 球队历年薪金状况表
team_salary_situation = """CREATE TABLE IF NOT EXISTS team_salary_situation(
ss_id  int  NOT NULL  AUTO_INCREMENT,
ss_name  varchar(100)  NOT NULL  COMMENT '球队',
ss_season  varchar(100)  NOT NULL  COMMENT '赛季',
ss_player  varchar(100)  NOT NULL  COMMENT '球员',
ss_salary  varchar(100)  COMMENT '薪金',
PRIMARY KEY(ss_id)
)ENGINE=InnoDB;
"""

# 9 球队历年薪金总计表
team_salary_count = """CREATE TABLE IF NOT EXISTS team_salary_count(
sc_id  int  NOT NULL  AUTO_INCREMENT,
sc_name  varchar(100)  NOT NULL  COMMENT '球队',
sc_season  varchar(100)  NOT NULL  COMMENT '赛季',
sc_total  varchar(100)  COMMENT '总计薪金',
PRIMARY KEY(sc_id)
)ENGINE=InnoDB;
"""

# 10 球队队史巨星常规赛得分总计榜
team_regular_star_score_total = """CREATE TABLE IF NOT EXISTS team_regular_star_score_total(
rsst_id  int  NOT NULL AUTO_INCREMENT,
rsst_name  varchar(100)  NOT NULL  COMMENT '球队',
rsst_player  varchar(100)  NOT NULL  COMMENT '球员',
rsst_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsst_id)
)ENGINE=InnoDB;
"""

# 11 球队队史巨星常规赛得分场均榜
team_regular_star_score_average = """CREATE TABLE IF NOT EXISTS team_regular_star_score_average(
rssa_id  int  NOT NULL AUTO_INCREMENT,
rssa_name  varchar(100)  NOT NULL  COMMENT '球队',
rssa_player  varchar(100)  NOT NULL  COMMENT '球员',
rssa_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rssa_id)
)ENGINE=InnoDB;
"""

# 12 球队队史巨星常规赛篮板总计榜
team_regular_star_backboard_total = """CREATE TABLE IF NOT EXISTS team_regular_star_backboard_total(
rsbt_id  int  NOT NULL AUTO_INCREMENT,
rsbt_name  varchar(100)  NOT NULL  COMMENT '球队',
rsbt_player  varchar(100)  NOT NULL  COMMENT '球员',
rsbt_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsbt_id)
)ENGINE=InnoDB;
"""

# 13 球队队史巨星常规赛篮板场均榜
team_regular_star_backboard_average = """CREATE TABLE IF NOT EXISTS team_regular_star_backboard_average(
rsba_id  int  NOT NULL AUTO_INCREMENT,
rsba_name  varchar(100)  NOT NULL  COMMENT '球队',
rsba_player  varchar(100)  NOT NULL  COMMENT '球员',
rsba_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsba_id)
)ENGINE=InnoDB;
"""

# 14 球队队史巨星常规赛助攻总计榜
team_regular_star_assists_total = """CREATE TABLE IF NOT EXISTS team_regular_star_assists_total(
rsat_id  int  NOT NULL AUTO_INCREMENT,
rsat_name  varchar(100)  NOT NULL  COMMENT '球队',
rsat_player  varchar(100)  NOT NULL  COMMENT '球员',
rsat_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsat_id)
)ENGINE=InnoDB;
"""

# 15 球队队史巨星常规赛助攻场均榜
team_regular_star_assists_average = """CREATE TABLE IF NOT EXISTS team_regular_star_assists_average(
rsaa_id  int  NOT NULL AUTO_INCREMENT,
rsaa_name  varchar(100)  NOT NULL  COMMENT '球队',
rsaa_player  varchar(100)  NOT NULL  COMMENT '球员',
rsaa_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsaa_id)
)ENGINE=InnoDB;
"""

# 16 球队队史巨星常规赛抢断总计榜
team_regular_star_steal_total = """CREATE TABLE IF NOT EXISTS team_regular_star_steal_total(
rsst_id  int  NOT NULL AUTO_INCREMENT,
rsst_name  varchar(100)  NOT NULL  COMMENT '球队',
rsst_player  varchar(100)  NOT NULL  COMMENT '球员',
rsst_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsst_id)
)ENGINE=InnoDB;
"""

# 17 球队队史巨星常规赛抢断场均榜
team_regular_star_steal_average = """CREATE TABLE IF NOT EXISTS team_regular_star_steal_average(
rssa_id  int  NOT NULL AUTO_INCREMENT,
rssa_name  varchar(100)  NOT NULL  COMMENT '球队',
rssa_player  varchar(100)  NOT NULL  COMMENT '球员',
rssa_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rssa_id)
)ENGINE=InnoDB;
"""

# 18 球队队史巨星常规赛盖帽总计榜
team_regular_star_cap_total = """CREATE TABLE IF NOT EXISTS team_regular_star_cap_total(
rsct_id  int  NOT NULL AUTO_INCREMENT,
rsct_name  varchar(100)  NOT NULL  COMMENT '球队',
rsct_player  varchar(100)  NOT NULL  COMMENT '球员',
rsct_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsct_id)
)ENGINE=InnoDB;
"""

# 19 球队队史巨星常规赛盖帽场均榜
team_regular_star_cap_average = """CREATE TABLE IF NOT EXISTS team_regular_star_cap_average(
rsca_id  int  NOT NULL AUTO_INCREMENT,
rsca_name  varchar(100)  NOT NULL  COMMENT '球队',
rsca_player  varchar(100)  NOT NULL  COMMENT '球员',
rsca_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsca_id)
)ENGINE=InnoDB;
"""

# 20 球队队史巨星常规赛失误总计榜
team_regular_star_mistake_total = """CREATE TABLE IF NOT EXISTS team_regular_star_mistake_total(
rsmt_id  int  NOT NULL AUTO_INCREMENT,
rsmt_name  varchar(100)  NOT NULL  COMMENT '球队',
rsmt_player  varchar(100)  NOT NULL  COMMENT '球员',
rsmt_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsmt_id)
)ENGINE=InnoDB;
"""

# 21 球队队史巨星常规赛失误场均榜
team_regular_star_mistake_average = """CREATE TABLE IF NOT EXISTS team_regular_star_mistake_average(
rsma_id  int  NOT NULL AUTO_INCREMENT,
rsma_name  varchar(100)  NOT NULL  COMMENT '球队',
rsma_player  varchar(100)  NOT NULL  COMMENT '球员',
rsma_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsma_id)
)ENGINE=InnoDB;
"""

# 22 球队队史巨星常规赛犯规总计榜
team_regular_star_foul_total = """CREATE TABLE IF NOT EXISTS team_regular_star_foul_total(
rsft_id  int  NOT NULL AUTO_INCREMENT,
rsft_name  varchar(100)  NOT NULL  COMMENT '球队',
rsft_player  varchar(100)  NOT NULL  COMMENT '球员',
rsft_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsft_id)
)ENGINE=InnoDB;
"""

# 23 球队队史巨星常规赛犯规场均榜
team_regular_star_foul_average = """CREATE TABLE IF NOT EXISTS team_regular_star_foul_average(
rsfa_id  int  NOT NULL AUTO_INCREMENT,
rsfa_name  varchar(100)  NOT NULL  COMMENT '球队',
rsfa_player  varchar(100)  NOT NULL  COMMENT '球员',
rsfa_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsfa_id)
)ENGINE=InnoDB;
"""

# 24 球队队史巨星常规赛命中总计榜
team_regular_star_hit_total = """CREATE TABLE IF NOT EXISTS team_regular_star_hit_total(
rsht_id  int  NOT NULL AUTO_INCREMENT,
rsht_name  varchar(100)  NOT NULL  COMMENT '球队',
rsht_player  varchar(100)  NOT NULL  COMMENT '球员',
rsht_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsht_id)
)ENGINE=InnoDB;
"""

# 25 球队队史巨星常规赛命中率榜
team_regular_star_hit_rate = """CREATE TABLE IF NOT EXISTS team_regular_star_hit_rate(
rshr_id  int  NOT NULL AUTO_INCREMENT,
rshr_name  varchar(100)  NOT NULL  COMMENT '球队',
rshr_player  varchar(100)  NOT NULL  COMMENT '球员',
rshr_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rshr_id)
)ENGINE=InnoDB;
"""

# 26 球队队史巨星常规赛真实命中榜
team_regular_star_ture_hit = """CREATE TABLE IF NOT EXISTS team_regular_star_ture_hit(
rsth_id  int  NOT NULL AUTO_INCREMENT,
rsth_name  varchar(100)  NOT NULL  COMMENT '球队',
rsth_player  varchar(100)  NOT NULL  COMMENT '球员',
rsth_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsth_id)
)ENGINE=InnoDB;
"""

# 27 球队队史巨星常规赛三分命中总计榜
team_regular_star_tp_total = """CREATE TABLE IF NOT EXISTS team_regular_star_tp_total(
rstt_id  int  NOT NULL AUTO_INCREMENT,
rstt_name  varchar(100)  NOT NULL  COMMENT '球队',
rstt_player  varchar(100)  NOT NULL  COMMENT '球员',
rstt_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rstt_id)
)ENGINE=InnoDB;
"""

# 28 球队队史巨星常规赛三分命中率榜
team_regular_star_tp_hit_rate = """CREATE TABLE IF NOT EXISTS team_regular_star_tp_hit_rate(
rsthr_id  int  NOT NULL AUTO_INCREMENT,
rsthr_name  varchar(100)  NOT NULL  COMMENT '球队',
rsthr_player  varchar(100)  NOT NULL  COMMENT '球员',
rsthr_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsthr_id)
)ENGINE=InnoDB;
"""

# 29 球队队史巨星常规赛罚球总计榜
team_regular_star_penalty_total = """CREATE TABLE IF NOT EXISTS team_regular_star_penalty_total(
rspt_id  int  NOT NULL AUTO_INCREMENT,
rspt_name  varchar(100)  NOT NULL  COMMENT '球队',
rspt_player  varchar(100)  NOT NULL  COMMENT '球员',
rspt_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rspt_id)
)ENGINE=InnoDB;
"""

# 30 球队队史巨星常规赛罚球命中率榜
team_regular_star_penalty_hit_rate = """CREATE TABLE IF NOT EXISTS team_regular_star_penalty_hit_rate(
rsphr_id  int  NOT NULL AUTO_INCREMENT,
rsphr_name  varchar(100)  NOT NULL  COMMENT '球队',
rsphr_player  varchar(100)  NOT NULL  COMMENT '球员',
rsphr_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsphr_id)
)ENGINE=InnoDB;
"""

# 31 球队队史巨星常规赛打铁总计榜
team_regular_star_undefined_total = """CREATE TABLE IF NOT EXISTS team_regular_star_undefined_total(
rsut_id  int  NOT NULL AUTO_INCREMENT,
rsut_name  varchar(100)  NOT NULL  COMMENT '球队',
rsut_player  varchar(100)  NOT NULL  COMMENT '球员',
rsut_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsut_id)
)ENGINE=InnoDB;
"""

# 32 球队队史巨星常规赛打铁场均榜
team_regular_star_undefined_average = """CREATE TABLE IF NOT EXISTS team_regular_star_undefined_average(
rsua_id  int  NOT NULL AUTO_INCREMENT,
rsua_name  varchar(100)  NOT NULL  COMMENT '球队',
rsua_player  varchar(100)  NOT NULL  COMMENT '球员',
rsua_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsua_id)
)ENGINE=InnoDB;
"""

# 33 球队队史巨星常规赛出场次数榜
team_regular_star_appearance = """CREATE TABLE IF NOT EXISTS team_regular_star_appearance(
rsa_id  int  NOT NULL AUTO_INCREMENT,
rsa_name  varchar(100)  NOT NULL  COMMENT '球队',
rsa_player  varchar(100)  NOT NULL  COMMENT '球员',
rsa_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(rsa_id)
)ENGINE=InnoDB;
"""

# 34 球队队史巨星季后赛得分总计榜
team_playoff_star_score_total = """CREATE TABLE IF NOT EXISTS team_playoff_star_score_total(
psst_id  int  NOT NULL AUTO_INCREMENT,
psst_name  varchar(100)  NOT NULL  COMMENT '球队',
psst_player  varchar(100)  NOT NULL  COMMENT '球员',
psst_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psst_id)
)ENGINE=InnoDB;
"""

# 35 球队队史巨星季后赛得分场均榜
team_playoff_star_score_average = """CREATE TABLE IF NOT EXISTS team_playoff_star_score_average(
pssa_id  int  NOT NULL AUTO_INCREMENT,
pssa_name  varchar(100)  NOT NULL  COMMENT '球队',
pssa_player  varchar(100)  NOT NULL  COMMENT '球员',
pssa_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(pssa_id)
)ENGINE=InnoDB;
"""

# 36 球队队史巨星季后赛篮板总计榜
team_playoff_star_backboard_total = """CREATE TABLE IF NOT EXISTS team_playoff_star_backboard_total(
psbt_id  int  NOT NULL AUTO_INCREMENT,
psbt_name  varchar(100)  NOT NULL  COMMENT '球队',
psbt_player  varchar(100)  NOT NULL  COMMENT '球员',
psbt_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psbt_id)
)ENGINE=InnoDB;
"""

# 37 球队队史巨星季后赛篮板场均榜
team_playoff_star_backboard_average = """CREATE TABLE IF NOT EXISTS team_playoff_star_backboard_average(
psba_id  int  NOT NULL AUTO_INCREMENT,
psba_name  varchar(100)  NOT NULL  COMMENT '球队',
psba_player  varchar(100)  NOT NULL  COMMENT '球员',
psba_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psba_id)
)ENGINE=InnoDB;
"""

# 38 球队队史巨星季后赛助攻总计榜
team_playoff_star_assists_total = """CREATE TABLE IF NOT EXISTS team_playoff_star_assists_total(
psat_id  int  NOT NULL AUTO_INCREMENT,
psat_name  varchar(100)  NOT NULL  COMMENT '球队',
psat_player  varchar(100)  NOT NULL  COMMENT '球员',
psat_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psat_id)
)ENGINE=InnoDB;
"""

# 39 球队队史巨星季后赛助攻场均榜
team_playoff_star_assists_average = """CREATE TABLE IF NOT EXISTS team_playoff_star_assists_average(
psaa_id  int  NOT NULL AUTO_INCREMENT,
psaa_name  varchar(100)  NOT NULL  COMMENT '球队',
psaa_player  varchar(100)  NOT NULL  COMMENT '球员',
psaa_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psaa_id)
)ENGINE=InnoDB;
"""

# 40 球队队史巨星季后赛抢断总计榜
team_playoff_star_steal_total = """CREATE TABLE IF NOT EXISTS team_playoff_star_steal_total(
psst_id  int  NOT NULL AUTO_INCREMENT,
psst_name  varchar(100)  NOT NULL  COMMENT '球队',
psst_player  varchar(100)  NOT NULL  COMMENT '球员',
psst_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psst_id)
)ENGINE=InnoDB;
"""

# 41 球队队史巨星季后赛抢断场均榜
team_playoff_star_steal_average = """CREATE TABLE IF NOT EXISTS team_playoff_star_steal_average(
pssa_id  int  NOT NULL AUTO_INCREMENT,
pssa_name  varchar(100)  NOT NULL  COMMENT '球队',
pssa_player  varchar(100)  NOT NULL  COMMENT '球员',
pssa_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(pssa_id)
)ENGINE=InnoDB;
"""

# 42 球队队史巨星季后赛盖帽总计榜
team_playoff_star_cap_total = """CREATE TABLE IF NOT EXISTS team_playoff_star_cap_total(
psct_id  int  NOT NULL AUTO_INCREMENT,
psct_name  varchar(100)  NOT NULL  COMMENT '球队',
psct_player  varchar(100)  NOT NULL  COMMENT '球员',
psct_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psct_id)
)ENGINE=InnoDB;
"""

# 43 球队队史巨星季后赛盖帽场均榜
team_playoff_star_cap_average = """CREATE TABLE IF NOT EXISTS team_playoff_star_cap_average(
psca_id  int  NOT NULL AUTO_INCREMENT,
psca_name  varchar(100)  NOT NULL  COMMENT '球队',
psca_player  varchar(100)  NOT NULL  COMMENT '球员',
psca_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psca_id)
)ENGINE=InnoDB;
"""

# 44 球队队史巨星季后赛失误总计榜
team_playoff_star_mistake_total = """CREATE TABLE IF NOT EXISTS team_playoff_star_mistake_total(
psmt_id  int  NOT NULL AUTO_INCREMENT,
psmt_name  varchar(100)  NOT NULL  COMMENT '球队',
psmt_player  varchar(100)  NOT NULL  COMMENT '球员',
psmt_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psmt_id)
)ENGINE=InnoDB;
"""

# 45 球队队史巨星季后赛失误场均榜
team_playoff_star_mistake_average = """CREATE TABLE IF NOT EXISTS team_playoff_star_mistake_average(
psma_id  int  NOT NULL AUTO_INCREMENT,
psma_name  varchar(100)  NOT NULL  COMMENT '球队',
psma_player  varchar(100)  NOT NULL  COMMENT '球员',
psma_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psma_id)
)ENGINE=InnoDB;
"""

# 46 球队队史巨星季后赛犯规总计榜
team_playoff_star_foul_total = """CREATE TABLE IF NOT EXISTS team_playoff_star_foul_total(
psft_id  int  NOT NULL AUTO_INCREMENT,
psft_name  varchar(100)  NOT NULL  COMMENT '球队',
psft_player  varchar(100)  NOT NULL  COMMENT '球员',
psft_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psft_id)
)ENGINE=InnoDB;
"""

# 47 球队队史巨星季后赛犯规场均榜
team_playoff_star_foul_average = """CREATE TABLE IF NOT EXISTS team_playoff_star_foul_average(
psfa_id  int  NOT NULL AUTO_INCREMENT,
psfa_name  varchar(100)  NOT NULL  COMMENT '球队',
psfa_player  varchar(100)  NOT NULL  COMMENT '球员',
psfa_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psfa_id)
)ENGINE=InnoDB;
"""

# 48 球队队史巨星季后赛命中总计榜
team_playoff_star_hit_total = """CREATE TABLE IF NOT EXISTS team_playoff_star_hit_total(
psht_id  int  NOT NULL AUTO_INCREMENT,
psht_name  varchar(100)  NOT NULL  COMMENT '球队',
psht_player  varchar(100)  NOT NULL  COMMENT '球员',
psht_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psht_id)
)ENGINE=InnoDB;
"""

# 49 球队队史巨星季后赛命中率榜
team_playoff_star_hit_rate = """CREATE TABLE IF NOT EXISTS team_playoff_star_hit_rate(
pshr_id  int  NOT NULL AUTO_INCREMENT,
pshr_name  varchar(100)  NOT NULL  COMMENT '球队',
pshr_player  varchar(100)  NOT NULL  COMMENT '球员',
pshr_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(pshr_id)
)ENGINE=InnoDB;
"""

# 50 球队队史巨星季后赛真实命中榜
team_playoff_star_ture_hit = """CREATE TABLE IF NOT EXISTS team_playoff_star_ture_hit(
psth_id  int  NOT NULL AUTO_INCREMENT,
psth_name  varchar(100)  NOT NULL  COMMENT '球队',
psth_player  varchar(100)  NOT NULL  COMMENT '球员',
psth_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psth_id)
)ENGINE=InnoDB;
"""

# 51 球队队史巨星季后赛三分命中总计榜
team_playoff_star_tp_total = """CREATE TABLE IF NOT EXISTS team_playoff_star_tp_total(
pstt_id  int  NOT NULL AUTO_INCREMENT,
pstt_name  varchar(100)  NOT NULL  COMMENT '球队',
pstt_player  varchar(100)  NOT NULL  COMMENT '球员',
pstt_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(pstt_id)
)ENGINE=InnoDB;
"""

# 52 球队队史巨星季后赛三分命中率榜
team_playoff_star_tp_hit_rate = """CREATE TABLE IF NOT EXISTS team_playoff_star_tp_hit_rate(
psthr_id  int  NOT NULL AUTO_INCREMENT,
psthr_name  varchar(100)  NOT NULL  COMMENT '球队',
psthr_player  varchar(100)  NOT NULL  COMMENT '球员',
psthr_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psthr_id)
)ENGINE=InnoDB;
"""

# 53 球队队史巨星季后赛罚球总计榜
team_playoff_star_penalty_total = """CREATE TABLE IF NOT EXISTS team_playoff_star_penalty_total(
pspt_id  int  NOT NULL AUTO_INCREMENT,
pspt_name  varchar(100)  NOT NULL  COMMENT '球队',
pspt_player  varchar(100)  NOT NULL  COMMENT '球员',
pspt_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(pspt_id)
)ENGINE=InnoDB;
"""

# 54 球队队史巨星季后赛罚球命中率榜
team_playoff_star_penalty_hit_rate = """CREATE TABLE IF NOT EXISTS team_playoff_star_penalty_hit_rate(
psphr_id  int  NOT NULL AUTO_INCREMENT,
psphr_name  varchar(100)  NOT NULL  COMMENT '球队',
psphr_player  varchar(100)  NOT NULL  COMMENT '球员',
psphr_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psphr_id)
)ENGINE=InnoDB;
"""

# 55 球队队史巨星季后赛打铁总计榜
team_playoff_star_undefined_total = """CREATE TABLE IF NOT EXISTS team_playoff_star_undefined_total(
psut_id  int  NOT NULL AUTO_INCREMENT,
psut_name  varchar(100)  NOT NULL  COMMENT '球队',
psut_player  varchar(100)  NOT NULL  COMMENT '球员',
psut_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psut_id)
)ENGINE=InnoDB;
"""

# 56 球队队史巨星季后赛打铁场均榜
team_playoff_star_undefined_average = """CREATE TABLE IF NOT EXISTS team_playoff_star_undefined_average(
psua_id  int  NOT NULL AUTO_INCREMENT,
psua_name  varchar(100)  NOT NULL  COMMENT '球队',
psua_player  varchar(100)  NOT NULL  COMMENT '球员',
psua_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psua_id)
)ENGINE=InnoDB;
"""

# 57 球队队史巨星季后赛出场次数榜
team_playoff_star_appearance = """CREATE TABLE IF NOT EXISTS team_playoff_star_appearance(
psa_id  int  NOT NULL AUTO_INCREMENT,
psa_name  varchar(100)  NOT NULL  COMMENT '球队',
psa_player  varchar(100)  NOT NULL  COMMENT '球员',
psa_value  varchar(100)  NOT NULL  COMMENT '值',
PRIMARY KEY(psa_id)
)ENGINE=InnoDB;
"""

# 58 球队队史巨星巅峰赛季数据表
team_superstar_peak_season_data = """CREATE TABLE IF NOT EXISTS team_superstar_peak_season_data(
spsd_id  int  NOT NULL  AUTO_INCREMENT,
spsd_name  varchar(100)  NOT NULL  COMMENT '球队',
spsd_player  varchar(100)  NOT NULL  COMMENT '球员',
spsd_season  varchar(100)  COMMENT '赛季',
spsd_seasons  varchar(100)  COMMENT '场次',
spsd_average_score  varchar(100)  COMMENT '场均得分',
spsd_average_backboard  varchar(100)  COMMENT '场均篮板',
spsd_average_assists  varchar(100)  COMMENT '场均助攻',
spsd_average_cap  varchar(100)  COMMENT '场均盖帽',
spsd_average_steal  varchar(100)  COMMENT '场均抢断',
PRIMARY KEY(spsd_id)
)ENGINE=InnoDB;
"""

